Name |
|
Code |
|
Comment |
Historyczne wpisy zawierajace stan danych wszystkich kolumn tabeli ContractData. |
Name |
Code |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(19,4) |
Mandatory |
No |
Comment |
liczba rozl. jedn. miary zawartych w jednym opakowaniu |
Name |
|
Code |
|
Data Type |
NUMBER(12,4) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Poczatek obowiazywania taryfy |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Koniec obowiazywania taryfy |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
Czy dany wpis jest aktywny |
Name |
|
Code |
|
Data Type |
NUMBER(22,6) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(19,4) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(8,4) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(5) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(19,4) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(14,4) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(2) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(5) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(5) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(5) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(15) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(5) |
Mandatory |
No |
Comment |
Miesiac poczatku okresu rozliczeniowego |
Name |
|
Code |
|
Data Type |
NUMBER(5) |
Mandatory |
No |
Comment |
Miesiac konca okresu rozliczeniowego |
Name |
|
Code |
|
Data Type |
VARCHAR2(16) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10,2) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Id ostatniego kontraktu, który spowodowal zmiane danych na ContractData |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
Code |
Primary |
X |
Name |
|
Code |
|
Primary |
Yes |
Comment |
|
|
|
|